<?php
/**
 * * Definition data structure
 * @author DuongNV
 * @copyright Tan MA JSC
 * @category definition constant
 * @version 1.1
 */

/**
 * ==================================== DEFINITION PAGE TABLE
 * =========================================== *
 */
// ------------ TABLE PAGE_WEBINFO --------------------
define( "WEBINFO", "page_webinfo");
define( "WEBINFO_ID", "ID");
define( "WEBINFO_TITLETAG", "TitleTag");
define( "WEBINFO_ICON", "Icon");
define( "WEBINFO_METAKEYWORD", "MetaKeyword");
define( "WEBINFO_METADESCRIPTION", "MetaDescription");
define( "WEBINFO_HEADERSCRIPT", "HeaderScript");
define( "WEBINFO_BODYSCRIPT", "BodyScript");
define( "WEBINFO_BACKLINK", "BackLink");
define( "WEBINFO_LANGUAGE", "Language");
define( "WEBINFO_EDITBY", "EditBy");

$webinfoFullColArray = array(WEBINFO_ID, WEBINFO_TITLETAG, WEBINFO_ICON, WEBINFO_METAKEYWORD, WEBINFO_METADESCRIPTION, WEBINFO_HEADERSCRIPT, WEBINFO_BODYSCRIPT, WEBINFO_BACKLINK, WEBINFO_LANGUAGE, WEBINFO_EDITBY);
$webinfoShortColArray = array(WEBINFO_ID, WEBINFO_TITLETAG, WEBINFO_LANGUAGE, WEBINFO_EDITBY);

// ------------ TABLE PAGE_ORGANINFO --------------------
define( "ORGANINFO", "page_organinfo");
define( "ORGANINFO_ID", "ID");
define( "ORGANINFO_ORGANIZATION", "Organization");
define( "ORGANINFO_ADDRESS", "Address");
define( "ORGANINFO_PHONENUMBER", "PhoneNumber");
define( "ORGANINFO_FAXNUMBER", "FaxNumber");
define( "ORGANINFO_EMAIL", "Email");
define( "ORGANINFO_HOTLINE", "Hotline");
define( "ORGANINFO_MAPADDRESS", "MapAddress");
define( "ORGANINFO_FACEBOOKSITE", "FacebookSite");
define( "ORGANINFO_LANGUAGE", "Language");
define( "ORGANINFO_EDITBY", "EditBy");

$organinfoFullColArray = array(ORGANINFO_ID, ORGANINFO_ORGANIZATION, ORGANINFO_ADDRESS, ORGANINFO_PHONENUMBER, ORGANINFO_FAXNUMBER, ORGANINFO_EMAIL, ORGANINFO_HOTLINE, ORGANINFO_MAPADDRESS, ORGANINFO_FACEBOOKSITE, ORGANINFO_LANGUAGE, ORGANINFO_EDITBY);
$organinfoShortColArray = array(ORGANINFO_ID, ORGANINFO_ORGANIZATION, ORGANINFO_LANGUAGE, ORGANINFO_EDITBY);

// ------------ TABLE PAGE_USERS --------------------
define( "USERS", "page_users");
define( "USER_ID", "ID");
define( "USER_USERNAME", "Username");
define( "USER_PASSWORD", "Password");
define( "USER_EMAIL", "Email");
define( "USER_ROLE", "Role");
define( "USER_TYPE", "Type");
define( "USER_FULLNAME", "FullName");
define( "USER_IMAGE", "Image");
define( "USER_CARDID", "CardID");
define( "USER_DATEOFBIRTH", "DateOfBirth");
define( "USER_ADDRESS", "Address");
define( "USER_CELLPHONE", "CellPhone");
define( "USER_HOMEPHONE", "HomePhone");

$userFullColArray = array(USER_ID, USER_USERNAME, USER_EMAIL, USER_ROLE, USER_FULLNAME, USER_IMAGE, USER_CARDID, USER_DATEOFBIRTH, USER_ADDRESS, USER_CELLPHONE, USER_HOMEPHONE);
$userShortColArray = array(USER_ID, USER_USERNAME, USER_EMAIL, USER_ROLE, USER_FULLNAME, USER_IMAGE);

// ------------ TABLE PAGE_IMAGES --------------------
define( "PAGEIMAGES", "page_images");
define( "PAGEIMAGE_ID", "ID");
define( "PAGEIMAGE_TYPE", "Type");
define( "PAGEIMAGE_IMAGELINK", "ImageLink");
define( "PAGEIMAGE_IMAGETITLE", "ImageTitle");
define( "PAGEIMAGE_IMAGEALT", "ImageAlt");
define( "PAGEIMAGE_DESCRIPTION", "Description");
define( "PAGEIMAGE_LINK", "Link");
define( "PAGEIMAGE_POSITION", "Position");
define( "PAGEIMAGE_UPLOADTIME", "UploadTime");
define( "PAGEIMAGE_LANGUAGE", "Language");
define( "PAGEIMAGE_EDITBY", "EditBy");

$pageimageFullColArray = array(PAGEIMAGE_ID, PAGEIMAGE_TYPE, PAGEIMAGE_IMAGELINK, PAGEIMAGE_IMAGETITLE, PAGEIMAGE_IMAGEALT, PAGEIMAGE_DESCRIPTION, PAGEIMAGE_LINK, PAGEIMAGE_POSITION, PAGEIMAGE_UPLOADTIME, PAGEIMAGE_LANGUAGE, PAGEIMAGE_EDITBY);
$pageimageShortColArray = array(PAGEIMAGE_ID, PAGEIMAGE_IMAGELINK, PAGEIMAGE_IMAGETITLE, PAGEIMAGE_IMAGEALT);

// ------------ TABLE PAGE_IMAGES --------------------
define( "PAGEPOPUP", "page_popup");
define( "PAGEPOPUP_ID", "ID");
define( "PAGEPOPUP_TYPE", "Type");
define( "PAGEPOPUP_TITLE", "Title");
define( "PAGEPOPUP_FILELINK", "FileLink");
define( "PAGEPOPUP_FILETYPE", "FileType");
define( "PAGEPOPUP_IMAGETITLE", "ImageTitle");
define( "PAGEPOPUP_IMAGEALT", "ImageAlt");
define( "PAGEPOPUP_FLASHWIDTH", "FlashWidth");
define( "PAGEPOPUP_FLASHHEIGHT", "FlashHeight");
define( "PAGEPOPUP_LINK", "Link");
define( "PAGEPOPUP_UPDATETIME", "UpdateTime");
define( "PAGEPOPUP_LANGUAGE", "Language");
define( "PAGEPOPUP_EDITBY", "EditBy");

$pagepopupFullColArray = array(PAGEPOPUP_ID, PAGEPOPUP_TYPE, PAGEPOPUP_TITLE, PAGEPOPUP_FILELINK, PAGEPOPUP_FILETYPE, PAGEPOPUP_IMAGETITLE, PAGEPOPUP_IMAGEALT, PAGEPOPUP_LINK, PAGEPOPUP_FLASHWIDTH, PAGEPOPUP_FLASHHEIGHT, PAGEPOPUP_UPDATETIME, PAGEPOPUP_LANGUAGE, PAGEPOPUP_EDITBY);
$pagepopupShortColArray = array(PAGEPOPUP_ID, PAGEPOPUP_TYPE, PAGEPOPUP_FILELINK, PAGEPOPUP_EDITBY);

// ------------ TABLE PAGE_VISITORS --------------------
define( "VISITORS", "page_visitors");

define( "VISITOR_ID", "ID");
define( "VISITOR_SESSIONID", "SessionID");
define( "VISITOR_USERAGENT", "UserAgent");
define( "VISITOR_TIME", "Time");
define( "VISITOR_DATETIME", "DateTime");
define( "VISITOR_BROWSER", "Browser");
define( "VISITOR_MACADDRESS", "MacAddress");
define( "VISITOR_IPADDRESS", "IPAddress");
define( "VISITOR_OPERATIONSYTEM", "OperationSytem");
define( "VISITOR_DEVICES", "Devices");
define( "VISITOR_LOCATION", "Location");
define( "VISITOR_LANGUAGE", "Language");
define( "VISITOR_NUMBERLINK", "NumberLink");
define( "VISITOR_OUTTIME", "OutTime");

$visitorFullColArray = array(VISITOR_ID, VISITOR_SESSIONID, VISITOR_USERAGENT, VISITOR_TIME, VISITOR_DATETIME, VISITOR_BROWSER, VISITOR_MACADDRESS, VISITOR_IPADDRESS, VISITOR_OPERATIONSYTEM, VISITOR_DEVICES, VISITOR_LOCATION, VISITOR_LANGUAGE, VISITOR_NUMBERLINK, VISITOR_OUTTIME);
$visitorShortColArray = array(VISITOR_ID, VISITOR_SESSIONID, VISITOR_USERAGENT, VISITOR_TIME, VISITOR_DATETIME, VISITOR_BROWSER, VISITOR_MACADDRESS, VISITOR_IPADDRESS, VISITOR_OPERATIONSYTEM, VISITOR_DEVICES, VISITOR_LOCATION, VISITOR_LANGUAGE, VISITOR_NUMBERLINK, VISITOR_OUTTIME);

// ------------ TABLE PAGE_SUPPORTERS --------------------
define( "SUPPORTERS", "page_supporters");

define( "SUPPORT_ID", "ID");
define( "SUPPORT_NAME", "Name");
define( "SUPPORT_TITLE", "Title");
define( "SUPPORT_PHONENUMBER", "PhoneNumber");
define( "SUPPORT_EMAIL", "Email");
define( "SUPPORT_YAHOO", "Yahoo");
define( "SUPPORT_SKYPE", "Skype");
define( "SUPPORT_POSITION", "Position");
define( "SUPPORT_LANGUAGE", "Language");
define( "SUPPORT_EDITBY", "EditBy");

$supportFullColArray = array(SUPPORT_ID, SUPPORT_NAME, SUPPORT_TITLE, SUPPORT_PHONENUMBER, SUPPORT_EMAIL, SUPPORT_YAHOO, SUPPORT_SKYPE, SUPPORT_POSITION, SUPPORT_LANGUAGE, SUPPORT_EDITBY);
$supportShortColArray = array(SUPPORT_ID, SUPPORT_NAME, SUPPORT_PHONENUMBER, SUPPORT_YAHOO, SUPPORT_EDITBY);

/**
 * ==================================== DEFINITION NEWS TABLE
 * =========================================== *
 */

// ------------ TABLE NEWS_CATEGORIES --------------------
define( "CATEGORIES", "view_categories");
define( "CATEGORY_ID", "ID");
define( "CATEGORY_CODE", "Code");
define( "CATEGORY_TITLE", "Title");
define( "CATEGORY_URL", "URL");
define( "CATEGORY_IMAGELINK", "ImageLink");
define( "CATEGORY_PAGEIMAGE", "PageImage");
define( "CATEGORY_FID", "FID");
define( "CATEGORY_TYPE", "Type");
define( "CATEGORY_DESCRIPTION", "Description");
define( "CATEGORY_HOMESHOW", "HomeShow");
define( "CATEGORY_HOMEVIEW", "HomeView");
define( "CATEGORY_TITLETAG", "TitleTag");
define( "CATEGORY_METAKEYWORD", "MetaKeyword");
define( "CATEGORY_METADESCRIPTION", "MetaDescription");
define( "CATEGORY_POSITION", "Position");
define( "CATEGORY_UPDATETIME", "UpdateTime");
define( "CATEGORY_LANGUAGE", "Language");
define( "CATEGORY_EDITBY", "EditBy");

$categoryFullColArray = array(CATEGORY_ID, CATEGORY_CODE, CATEGORY_TITLE, CATEGORY_URL, CATEGORY_IMAGELINK, CATEGORY_PAGEIMAGE, CATEGORY_FID, CATEGORY_TYPE, CATEGORY_DESCRIPTION, CATEGORY_HOMESHOW, CATEGORY_HOMEVIEW, CATEGORY_TITLETAG, CATEGORY_METAKEYWORD, CATEGORY_METADESCRIPTION, CATEGORY_POSITION, CATEGORY_UPDATETIME, CATEGORY_LANGUAGE, CATEGORY_EDITBY);
$categoryShortColArray = array(CATEGORY_ID, CATEGORY_TITLE, CATEGORY_TYPE, CATEGORY_UPDATETIME, CATEGORY_EDITBY);

// ------------ TABLE NEWS_ARTICLES --------------------
define( "ARTICLES", "view_articles");
define( "ARTICLE_ID", "ID");
define( "ARTICLE_CODE", "Code");
define( "ARTICLE_TITLE", "Title");
define( "ARTICLE_URL", "URL");
define( "ARTICLE_IMAGELINK", "ImageLink");
define( "ARTICLE_CATEGORYID", "CategoryID");
define( "ARTICLE_DESCRIPTION", "Description");
define( "ARTICLE_CONTENT", "Content");
define( "ARTICLE_HOT", "Hot");
define( "ARTICLE_FESH", "Fesh");
define( "ARTICLE_TITLETAG", "TitleTag");
define( "ARTICLE_METAKEYWORD", "MetaKeyword");
define( "ARTICLE_METADESCRIPTION", "MetaDescription");
define( "ARTICLE_TAGKEYWORD", "TagKeyword");
define( "ARTICLE_UPDATETIME", "UpdateTime");
define( "ARTICLE_VIEWNUMBER", "ViewNumber");
define( "ARTICLE_LANGUAGE", "Language");
define( "ARTICLE_EDITBY", "EditBy");

$articleFullColArray = array(ARTICLE_ID, ARTICLE_TITLE, ARTICLE_URL, ARTICLE_IMAGELINK, ARTICLE_CATEGORYID, ARTICLE_DESCRIPTION, ARTICLE_CONTENT, ARTICLE_HOT, ARTICLE_FESH, ARTICLE_METAKEYWORD, ARTICLE_TITLETAG, ARTICLE_METADESCRIPTION, ARTICLE_TAGKEYWORD, ARTICLE_UPDATETIME, ARTICLE_VIEWNUMBER, ARTICLE_LANGUAGE, ARTICLE_EDITBY);
$articleShortColArray = array(ARTICLE_ID, ARTICLE_TITLE, ARTICLE_CATEGORYID, ARTICLE_EDITBY);

// ------------ TABLE NEWS_ALBUMS --------------------
define( "COLLECTION", "view_collection");
define( "COLLECTION_ID", "ID");
define( "COLLECTION_CODE", "Code");
define( "COLLECTION_TITLE", "Title");
define( "COLLECTION_URL", "URL");
define( "COLLECTION_IMAGELINK", "ImageLink");
define( "COLLECTION_CATEGORYID", "CategoryID");
define( "COLLECTION_DESCRIPTION", "Description");
define( "COLLECTION_HOT", "Hot");
define( "COLLECTION_FESH", "Fesh");
define( "COLLECTION_TITLETAG", "TitleTag");
define( "COLLECTION_METAKEYWORD", "MetaKeyword");
define( "COLLECTION_METADESCRIPTION", "MetaDescription");
define( "COLLECTION_TAGKEYWORD", "TagKeyword");
define( "COLLECTION_UPDATETIME", "UpdateTime");
define( "COLLECTION_VIEWNUMBER", "ViewNumber");
define( "COLLECTION_LANGUAGE", "Language");
define( "COLLECTION_EDITBY", "EditBy");

$albumFullColArray = array(COLLECTION_ID, COLLECTION_CODE, COLLECTION_TITLE, COLLECTION_URL, COLLECTION_IMAGELINK, COLLECTION_CATEGORYID, COLLECTION_DESCRIPTION, COLLECTION_HOT, COLLECTION_FESH, COLLECTION_TITLETAG, COLLECTION_METAKEYWORD, COLLECTION_METADESCRIPTION, COLLECTION_TAGKEYWORD, COLLECTION_UPDATETIME, COLLECTION_VIEWNUMBER, COLLECTION_LANGUAGE, COLLECTION_EDITBY);
$albumShortColArray = array(COLLECTION_ID, COLLECTION_TITLE, COLLECTION_CATEGORYID, COLLECTION_EDITBY);

// ------------ TABLE NEWS_IMAGES --------------------
define( "FILES", "view_files");
define( "FILE_ID", "ID");
define( "FILE_CID", "CategoryID");
define( "FILE_CATEGORYID", "CategoryID");
define( "FILE_TITLE", "Title");
define( "FILE_TYPE", "Type");
define( "FILE_LINK", "Link");
define( "FILE_POSITION", "Position");
define( "FILE_UPDATETIME", "UpdateTime");
define( "FILE_VIEWNUMBER", "ViewNumber");
define( "FILE_LANGUAGE", "Language");
define( "FILE_UPLOADBY", "UploadBy");

$fileFullColArray = array(FILE_ID, FILE_CID, FILE_TITLE, FILE_TYPE, FILE_LINK, FILE_POSITION, FILE_UPDATETIME, FILE_VIEWNUMBER, FILE_LANGUAGE, FILE_UPLOADBY);
$fileShortColArray = array(FILE_ID, FILE_CID, FILE_TITLE, FILE_UPLOADBY);

// ------------ TABLE NEWS_VIDEOS --------------------
define( "VIDEOS", "view_videos");
define( "VIDEO_ID", "ID");
define( "VIDEO_CODE", "Code");
define( "VIDEO_TITLE", "Title");
define( "VIDEO_URL", "URL");
define( "VIDEO_IMAGELINK", "ImageLink");
define( "VIDEO_CATEGORYID", "CategoryID");
define( "VIDEO_DESCRIPTION", "Description");
define( "VIDEO_VIDEOLINK", "VideoLink");
define( "VIDEO_HOT", "Hot");
define( "VIDEO_FESH", "Fesh");
define( "VIDEO_TITLETAG", "TitleTag");
define( "VIDEO_METAKEYWORD", "MetaKeyword");
define( "VIDEO_METADESCRIPTION", "MetaDescription");
define( "VIDEO_TAGKEYWORD", "TagKeyword");
define( "VIDEO_UPDATETIME", "UploadTime");
define( "VIDEO_VIEWNUMBER", "ViewNumber");
define( "VIDEO_LANGUAGE", "Language");
define( "VIDEO_EDITBY", "EditBy");

$videoFullColArray = array(VIDEO_ID, VIDEO_CODE, VIDEO_TITLE, VIDEO_URL, VIDEO_IMAGELINK, VIDEO_CATEGORYID, VIDEO_DESCRIPTION, VIDEO_VIDEOLINK, VIDEO_HOT, VIDEO_FESH, VIDEO_TITLETAG, VIDEO_METAKEYWORD, VIDEO_METADESCRIPTION, VIDEO_UPDATETIME, VIDEO_VIEWNUMBER, VIDEO_LANGUAGE, VIDEO_EDITBY);
$videoShortColArray = array(VIDEO_ID, VIDEO_TITLE, VIDEO_VIDEOLINK, VIDEO_EDITBY);

// ------------ TABLE NEWS_PRODUCTS --------------------
define( "PRODUCTS", "view_products");
define( "PRODUCT_ID", "ID");
define( "PRODUCT_URL", "URL");
define( "PRODUCT_TITLE", "Title");
define( "PRODUCT_PRODUCTCODE", "ProductCode");
define( "PRODUCT_MANUFACTURER", "Manufacturer");
define( "PRODUCT_MANUFACTURERCODE", "ManufacturerCode");
define( "PRODUCT_STATUS", "Status");
define( "PRODUCT_WARRANTY", "Warranty");
define( "PRODUCT_QUANTITY", "Quantity");
define( "PRODUCT_COLOR", "Color");
define( "PRODUCT_COLORCODE", "ColorCode");
define( "PRODUCT_SIZE", "Size");
define( "PRODUCT_TYPE", "Type");
define( "PRODUCT_CATEGORYID", "CategoryID");
define( "PRODUCT_IMAGELINK", "ImageLink");
define( "PRODUCT_PRICE", "Price");
define( "PRODUCT_CURRENCY", "Currency");
define( "PRODUCT_SHOWPRICE", "ShowPrice");
define( "PRODUCT_SHOWCURRENCY", "ShowCurrency");
define( "PRODUCT_PROMOTION", "Promotion");
define( "PRODUCT_SPACEPRODUCT", "SpaceProduct");
define( "PRODUCT_HOTFEATURE", "HotFeature");
define( "PRODUCT_CONTENT", "Content");
define( "PRODUCT_SPECIFICATION", "Specifications");
define( "PRODUCT_HOT", "Hot");
define( "PRODUCT_FESH", "Fesh");
define( "PRODUCT_TITLETAG", "TitleTag");
define( "PRODUCT_METADESCRIPTION", "MetaDescription");
define( "PRODUCT_METAKEYWORD", "MetaKeyword");
define( "PRODUCT_TAGKEYWORD", "TagKeyword");
define( "PRODUCT_UPDATETIME", "UpdateTime");
define( "PRODUCT_VIEWNUMBER", "ViewNumber");
define( "PRODUCT_LANGUAGE", "Language");
define( "PRODUCT_EDITBY", "EditBy");

$productFullColArray = array(PRODUCT_ID, PRODUCT_URL, PRODUCT_TITLE, PRODUCT_PRODUCTCODE, PRODUCT_MANUFACTURER, PRODUCT_MANUFACTURERCODE, PRODUCT_STATUS, PRODUCT_WARRANTY, PRODUCT_QUANTITY, PRODUCT_COLOR, PRODUCT_COLORCODE, PRODUCT_SIZE, PRODUCT_TYPE, PRODUCT_CATEGORYID, PRODUCT_IMAGELINK, PRODUCT_PRICE, PRODUCT_CURRENCY, PRODUCT_SHOWPRICE, PRODUCT_SHOWCURRENCY, PRODUCT_PROMOTION, PRODUCT_SPACEPRODUCT, PRODUCT_HOTFEATURE, PRODUCT_CONTENT, PRODUCT_SPECIFICATION, PRODUCT_HOT, PRODUCT_FESH, PRODUCT_TITLETAG, PRODUCT_METADESCRIPTION, PRODUCT_METAKEYWORD, PRODUCT_TAGKEYWORD, PRODUCT_UPDATETIME, PRODUCT_VIEWNUMBER, PRODUCT_LANGUAGE, PRODUCT_EDITBY);

$productShortColArray = array(PRODUCT_ID, PRODUCT_TITLE, PRODUCT_CATEGORYID, PRODUCT_UPDATETIME, PRODUCT_EDITBY);

// ------------ TABLE PAGE_IMAGES --------------------
define( "PRODUCTIMAGES", "product_images");
define( "PRODUCTIMAGE_ID", "ID");
define( "PRODUCTIMAGE_PID", "PID");
define( "PRODUCTIMAGE_IMAGELINK", "ImageLink");
define( "PRODUCTIMAGE_IMAGETITLE", "ImageTitle");
define( "PRODUCTIMAGE_IMAGEALT", "ImageAlt");
define( "PRODUCTIMAGE_POSITION", "Position");
define( "PRODUCTIMAGE_UPLOADTIME", "UploadTime");
define( "PRODUCTIMAGE_EDITBY", "UploadBy");

$productImageFullColArray = array(
		PRODUCTIMAGE_ID,
		PRODUCTIMAGE_PID,
		PRODUCTIMAGE_IMAGELINK,
		PRODUCTIMAGE_IMAGETITLE,
		PRODUCTIMAGE_IMAGEALT,
		PRODUCTIMAGE_POSITION,
		PRODUCTIMAGE_UPLOADTIME,
		PRODUCTIMAGE_EDITBY,
		);

// ------------ TABLE NEWS_SCENIC --------------------
define( "SCENICS", "view_scenic");
define( "SCENIC_ID", "ID");
define( "SCENIC_TITLE", "Title");
define( "SCENIC_URL", "URL");
define( "SCENIC_IMAGELINK", "ImageLink");
define( "SCENIC_CATEGORYID", "CategoryID");
define( "SCENIC_TYPE", "Type");
define( "SCENIC_COUNTRY", "Country");
define( "SCENIC_LOCATION", "Location");
define( "SCENIC_DESCRIPTION", "Description");
define( "SCENIC_CONTENT", "Content");
define( "SCENIC_HOT", "Hot");
define( "SCENIC_FESH", "Fesh");
define( "SCENIC_TITLETAG", "TitleTag");
define( "SCENIC_METAKEYWORD", "MetaKeyword");
define( "SCENIC_METADESCRIPTION", "MetaDescription");
define( "SCENIC_TAGKEYWORD", "TagKeyword");
define( "SCENIC_UPDATETIME", "UpdateTime");
define( "SCENIC_VIEWNUMBER", "ViewNumber");
define( "SCENIC_LANGUAGE", "Language");
define( "SCENIC_EDITBY", "EditBy");

$scenicFullColArray = array(SCENIC_ID, SCENIC_TITLE, SCENIC_URL, SCENIC_IMAGELINK, SCENIC_CATEGORYID, SCENIC_TYPE, SCENIC_COUNTRY, SCENIC_LOCATION, SCENIC_DESCRIPTION, SCENIC_CONTENT, SCENIC_HOT, SCENIC_FESH, SCENIC_TITLETAG, SCENIC_METAKEYWORD, SCENIC_METADESCRIPTION, SCENIC_TAGKEYWORD, SCENIC_UPDATETIME, SCENIC_VIEWNUMBER, SCENIC_LANGUAGE, SCENIC_EDITBY);

$scenicShortColArray = array(SCENIC_ID, SCENIC_TITLE, SCENIC_CATEGORYID, SCENIC_UPDATETIME, SCENIC_EDITBY);

// ------------ TABLE NEWS_TOURS --------------------
define( "TOURS", "view_tours");
define( "TOUR_ID", "ID");
define( "TOUR_URL", "URL");
define( "TOUR_TITLE", "Title");
define( "TOUR_TOURCODE", "TourCode");
define( "TOUR_STATUS", "Status");
define( "TOUR_TYPE", "Type");
define( "TOUR_CATEGORYID", "CategoryID");
define( "TOUR_IMAGELINK", "ImageLink");
define( "TOUR_PRICE", "Price");
define( "TOUR_CURRENCY", "Currency");
define( "TOUR_SHOWPRICE", "ShowPrice");
define( "TOUR_SHOWCURRENCY", "ShowCurrency");
define( "TOUR_PROMOTION", "Promotion");
define( "TOUR_DISCOUNT", "Discount");
define( "TOUR_LOCATION", "Location");
define( "TOUR_DESTINATION", "Destination");
define( "TOUR_TRANSPORT", "Transport");
define( "TOUR_DURATION", "Duration");
define( "TOUR_CALENDAR", "Calendar");
define( "TOUR_SCHEDULE", "Schedule");
define( "TOUR_DESCRIPTION", "Description");
define( "TOUR_CONTENT", "Content");
define( "TOUR_SPECIFICATIONS", "Specifications");
define( "TOUR_HOT", "Hot");
define( "TOUR_FESH", "Fesh");
define( "TOUR_TITLETAG", "TitleTag");
define( "TOUR_METADESCRIPTION", "MetaDescription");
define( "TOUR_METAKEYWORD", "MetaKeyword");
define( "TOUR_TAGKEYWORD", "TagKeyword");
define( "TOUR_UPDATETIME", "UpdateTime");
define( "TOUR_VIEWNUMBER", "ViewNumber");
define( "TOUR_LANGUAGE", "Language");
define( "TOUR_EDITBY", "EditBy");

$tourFullColArray = array(TOUR_ID, TOUR_URL, TOUR_TITLE, TOUR_TOURCODE, TOUR_STATUS, TOUR_TYPE, TOUR_CATEGORYID, TOUR_IMAGELINK, TOUR_PRICE, TOUR_CURRENCY, TOUR_SHOWPRICE, TOUR_SHOWCURRENCY, TOUR_PROMOTION, TOUR_DISCOUNT, TOUR_LOCATION, TOUR_DESTINATION, TOUR_TRANSPORT, TOUR_DURATION, TOUR_CALENDAR, TOUR_SCHEDULE, TOUR_DESCRIPTION, TOUR_CONTENT, TOUR_SPECIFICATIONS, TOUR_HOT, TOUR_FESH, TOUR_TITLETAG, TOUR_METADESCRIPTION, TOUR_METAKEYWORD, TOUR_TAGKEYWORD, TOUR_UPDATETIME, TOUR_VIEWNUMBER, TOUR_LANGUAGE, TOUR_EDITBY);

$tourShortColArray = array(TOUR_ID, TOUR_TITLE, TOUR_CATEGORYID, TOUR_UPDATETIME, TOUR_EDITBY);

// ------------ TABLE NEWS_TOURS --------------------
define( "SERVICES", "view_service");
define( "SERVICE_ID", "ID");
define( "SERVICE_CODE", "Code");
define( "SERVICE_TITLE", "Title");
define( "SERVICE_URL", "URL");
define( "SERVICE_IMAGELINK", "ImageLink");
define( "SERVICE_CATEGORYID", "CategoryID");
define( "SERVICE_TYPE", "Type");
define( "SERVICE_PRICE", "Price");
define( "SERVICE_CURRENCY", "Currency");
define( "SERVICE_SHOWPRICE", "ShowPrice");
define( "SERVICE_SHOWCURRENCY", "ShowCurrency");
define( "SERVICE_DESCRIPTION", "Description");
define( "SERVICE_PROMOTION", "Promotion");
define( "SERVICE_CONTENT", "Content");
define( "SERVICE_HOT", "Hot");
define( "SERVICE_FESH", "Fesh");
define( "SERVICE_TITLETAG", "TitleTag");
define( "SERVICE_METAKEYWORD", "MetaKeyword");
define( "SERVICE_METADESCRIPTION", "MetaDescription");
define( "SERVICE_TAGKEYWORD", "TagKeyword");
define( "SERVICE_UPDATETIME", "UpdateTime");
define( "SERVICE_VIEWNUMBER", "ViewNumber");
define( "SERVICE_LANGUAGE", "Language");
define( "SERVICE_EDITBY", "EditBy");

$serviceFullColArray = array(SERVICE_ID, SERVICE_CODE, SERVICE_TITLE, SERVICE_URL, SERVICE_IMAGELINK, SERVICE_CATEGORYID, SERVICE_TYPE, SERVICE_PRICE, SERVICE_CURRENCY, SERVICE_SHOWPRICE, SERVICE_SHOWCURRENCY, SERVICE_DESCRIPTION, SERVICE_PROMOTION, SERVICE_CONTENT, SERVICE_HOT, SERVICE_FESH, SERVICE_TITLETAG, SERVICE_METAKEYWORD, SERVICE_METADESCRIPTION, SERVICE_TAGKEYWORD, SERVICE_UPDATETIME, SERVICE_VIEWNUMBER, SERVICE_LANGUAGE, SERVICE_EDITBY);

$serviceShortColArray = array(SERVICE_ID, SERVICE_TITLE, SERVICE_CATEGORYID, SERVICE_UPDATETIME, SERVICE_EDITBY);

// ------------ TABLE DATA_TYPE --------------------
define( "DATATYPE", "data_type");
define( "DATATYPE_ID", "ID");
define( "DATATYPE_TABLENAME", "TableName");
define( "DATATYPE_ITEMID", "ItemID");
define( "DATATYPE_ITEMURL", "ItemURL");
define( "DATATYPE_VIEWNUMBER", "ViewNumber");
define( "DATATYPE_LANGUAGE", "Language");
define( "DATATYPE_EDITBY", "EditBy");

$dataTypeFullColArray = array(DATATYPE_ID, DATATYPE_TABLENAME, DATATYPE_ITEMID, DATATYPE_ITEMURL, DATATYPE_VIEWNUMBER, DATATYPE_LANGUAGE, DATATYPE_EDITBY);

?>